select col0 , lead(col0) over(partition by col7 order by col0 ) lead_col0 from "allTypsUniq.parquet" where col0 not in (2147483647,1073741823,1,-1,0,10000000 )